package com.service.bank.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.client.model.pojo.bank.Record;
import com.github.yulichang.base.MPJBaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.client.model.pojo.bank.Record;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Collection;
import java.util.Date;
import java.util.List;

/**
* @author liuwenju
* @description 针对表【record】的数据库操作Mapper
* @createDate 2024-04-01 20:55:27
* @Entity com.service.bank.pojo.Record
*/
public interface RecordMapper extends BaseMapper<Record> {



    Page<Record> selectLists(@Param("ipage") IPage<Record> ipage, @Param("bankCard") String bankCard);



    @Select("select * from record where to_card = #{bankCard} and operator_status = 0 order by create_time desc")
    Page<Record> selectListsa(@Param("ipage") IPage<Record> ipage,@Param("bankCard") String bankCard);

    @Select("select * from record where to_card = #{card} and operator_status = 1 order by create_time desc")
    Page<Record> selectListsac(@Param("ipage") IPage<Record> ipage,@Param("card") String card);

    @Select("select * from record where to_card = #{card} and operator_status = 2 order by create_time desc")
    Page<Record> selectListsat(@Param("ipage") IPage<Record> ipage, @Param("card") String card);
}




